How to update permissions for multiple records: batch update

The Set Record Security tool is designed to batch update values specified in the Security box. It is not designed to batch update all values specified on the Security tab. In other words, users / groups added to the Security box and permissions specified in the Permissions box will be batch updated with the Set Record Security tool, but a value selected in the Record Status: (Access) drop list or specified in the Department field, for example, will not be batch updated when the Set Record Security tool is run.

To batch update values in these other fields, use Global Replace.

For one record in the previous example:

  1. Permissions for group Everyone were modified by removing the Edit and Delete permissions.
  2. Group Admin was added and given Edit and Delete permissions.

The Set Record Security tool is designed to apply permissions to multiple records at once:

  1. Search for all records for which the same Record Level Security permissions are to apply.
  2. For one record, set the required permissions in the Security box (add or remove users / groups and tick / untick permissions).
  3. Save the record.
  4. Select Tools>Set Record Security>All Records from the Menu bar.

    Note: If you had selected a subset of records returned by your search at Step 1, you would select Tools>Set Record Security>Selected Records .

    The following message displays:

  5. If you click Yes, the update is processed with progress displayed in the Set Security box:

    db_set_security2.gif

  6. Click OK to close the Set Security box.